
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetRefDomains]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetRefDomains]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/******************************************************************
* Name:			GetRefDomains
* Purpose:		Retrieves all the unique domains
*
* PARAMETERS
* Name    					Description					
* -------------  				-------------------------------------------
* 
******************************************************************/

CREATE Procedure [dbo].[GetRefDomains]
AS
BEGIN

	SET NOCOUNT ON

	Select	Distinct RefDomain
	FROM RefCode
	ORDER BY RefDomain
	
	
END


GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF  